MS Excel To create a formula, you can use: Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time Cell references but not values Value and cell references Values but not cell references Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel displays the current cell address in the ___ Name Box Status Bar Formula Bar Title Bar Name Box Status Bar Formula Bar Title Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Max Average Sum Pmt Max Average Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value ? 0.57 Serial Number 50771 350 May 10, 2001 0.57 Serial Number 50771 350 May 10, 2001 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS