How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
Correct Answer :
B. F9
Related Questions
How can you find specific information in a list?
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
Excel files have a default extension of
Xls
Xlw
Wk1
123
Which command will you choose to convert a column of data into row?
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
The active cell:
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel