SIA Computer

11 September 2022
4.7 (114 reviews)
14 test answers

Unlock all answers in this set

Unlock answers (10)
question
False
answer
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
question
False
answer
The arithmetic operator, ^, directs Excel to perform the division operation.
question
False
answer
Point mode allows you to select cells for use in a formula by using the keyboard.
question
False
answer
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
question
False
answer
You can use the arrow keys to complete an entry in Point mode.
question
False
answer
Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.
question
False
answer
To use Range Finder to verify thtat a formula contains the intended cell references, click the cell with the formula you want to check.
question
False
answer
Dates that include years both before and after the year 2000 should be formatted with a two-digit year.
question
False
answer
When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.
question
False
answer
You cannot format an entire column at once.
question
False
answer
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
question
False, Functional considerations
answer
In designing a worksheet, VISUAL AESTHETICS should come first.
question
False, centering
answer
When cell entries are short, RIGHT-ALIGNING the entries within their respective columns improves the appearance of the worksheet.
question
False, fixed
answer
The Accounting number format assigns a FLOATING dollar sign.