Computer Applications - Formulas
When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.
False
When you enter a value in a worksheet cell, it automatically left-aligned.
False
When you run the spell checker in a workbook, Excel automatically checks the spelling in all worksheets at once.
False
What formula would you use to find the total value of a range of cells?
=SUM(cell range)
To format the cell value 44.54 as 44.540, you can use the increase decimal button.
False
What formula would you use to calculate the mean of a range of cells?
=AVERAGE( )
What formula counts the number of non-blank cells in a range?
=COUNTA( )
What formula would you use to insert a specific date?
=DATE( )
What formula would you use to find the largest value in a cell range?
=MAX(cell range)
To have Excel enter the lowest price from a range of prices, what formula would you use?
=MIN( range of cells )
What formula would you use to insert the CURRENT DATE?
=NOW( )
What formula would you use to round the number 24.7835 in cell A2 to two decimal places? (Write out the entire formula)
=ROUND(AVERAGE(24.7835),2)
The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed? A. =IF(B2>=60, "PASS" , "FAIL") B. =OR(B2>=60, "PASS" , "FAIL") C. =AND(B2>=60, "PASS" , "FAIL") D. =AND(B2>=60, "PASS" , "FAIL")
A. =IF(B2>=60, "PASS" , "FAIL")
To select nonadjacent cells or ranges on a worksheet, you can press and hold ______ while selecting each one A. CTRL B. ALT C. SHIFT D. ESC
A. CTRL
To delete a worksheet column, you can first select it by A. Clicking the column heading B. Double-clicking the column heading C. Clicking anywhere in the column D. Double-clicking anywhere in the column
A. Clicking the column heading
To format a range so that all values greater that $500 appear in red, which of the following can you use? A. Conditional formatting B. Cell formatting C. Cell styles D. Quick access toolbar
A. Conditioning formatting
Which of the following can you use to insert a formula using a function? A. Insert function dialogue box B. AutoSum button on the Ribbon C. AutoSum list arrow on the Ribbon D. Copy and paste a cell containing a function
A. Insert function dialogue box B. AutoSum button on the Ribbon C. AutoSum list arrow on the Ribbon D. Copy and paste a cell containing a function
In the formula =A8*$A$1, which of the following describes A8? A. Relative cell reference B. Absolute cell reference C. Function D. AutoSum
A. Relative cell reference
In the formula =A8*$A$1, which of the following describes A1? A. Relative cell reference B. Absolute cell reference C. Function D. AutoSum
B. Absolute cell reference
When should you use relative cell reference? A. When you want to preserve the exact cell address in the formula B. When you want to preserve the relationship to the formula location C. When you want to insert a function D. When you want to enter a sequential values in a range of cells
B. When you want to preserve the relationship to the formula location
Which of the following lets you edit the contents of a cell? A. Click the cell, click the status bar, and press enter B. Click the cell and click in the status bar C. Double-click the cell, click in the status bar, or just start typing D. Double-click the cell or click the formula bar
D. Double-click the cell or click the formula bar
Which of the following is a built-in formula that helps you perform complex calculations? A. Clipboard B. Mode indicator C. Named range D. Function
D. Function
Currency is an example of a number format.
True
To change the background color of a cell, you use the background color button.
True
You can edit the cell contents in the Formula bar or in the cell itself.
True
You can start Excel using the start button on the Windows task-bar to a shortcut on your desktop.
True
You can use the DELETE key to cleat cell contents.
True
