practive quiz 2 Flashcards
(18 cards)
to set a page break in excel, select the
first cell below the row where you want to insert the page break
the cell reference for the is the upper right cell reference
false
in excel, dates are - aligned in the cell by default, regardless of date formate
right
The code - will display the filename of the current workbook
&[File]
formatting changes only to the appearance of data- it does not affect the data itself
true
one way to ensure that you are using consistent formats is to copy and paste your forats using the format
painter
because excel stores dates and times as - you can apply different formats without affecting the date and time value
numbers
in the format cells dialog box, the - tab allows you to format currency by choosing decimal places, comma separators, and regular number displays
number
setting the - to a1:l1 will print only data in the those cells
print area
if you want to print only part of a worksheet, you can st a print area, which is the region of the worksheet that is sent to the printer
true
a conditional format applies formatting to a cell when its value meets a specified condition
true
a - is the space between the page content and the edges of the page
margin
information that prints on each page, like a company name or logo may be set as a
print title
conditional formats are dynamic, so a cell’s appearance will change to reflect its current value
true
to avoid splitting a worksheet in awkward places, you can insert a - to specify a specific breaking point
manual page break
conditional formats are dynamic, so a cell’s appearance will change to reflect its current value
true
because excel store dates and times as - you can apply different formats without affecting the date and time value
numbers
you can open the format cells dialog box right-clicking a cell or selected range and then clicking - on the shortcut menu
format cells
