You can do calculation in MS Excel just like using calculator., False, True, How do you determine the selected cell in a spreadsheet?, The Black border around it and the contents of the cell will appear in the formula bar, The cell address will appear on the status bar, What is the purpose of the horizontal navigation bar in the spreadsheet?, To move the view of the spreadsheet on the top or bottom of the screen, To move the view of the spreadsheet on the left or right of the screen, How do you change the column width to fit to the contents?, Double click the boundary, Drag the boundary to the left or to the right, The column heading is composed of what?, Letters, Sheet tabs, Every formula in MS Excel begins with which character?, Equals sign (=), Minus sign (–), What feature is used to keep rows or columns visible while scrolling?, Filtering, Freezing Panes, Which key should you press to accept the data entered in a cell?, Enter key, Esc key, What happens when you type in a cell that already contains data?, The old data is replaced, The old data remains, What command allows you to save a copy of a workbook with a different name?, Save, Save As, What feature is used to arrange data alphabetically or numerically?, Sorting, Filtering, What does the cell reference A1:D10 mean, A range of cells from A1 to D10, Only cells A1 and D10, Which file type is the default save format of MS Excel 2019?doesn't use it; and the user doesn't see it., .xlsx, .docx, An absolute cell reference remains the same when the formula is copied., True, False, What toolbar lets you access frequently used commands no matter which tab is selected?, Ribbon, Quick Access Toolbar, What box displays the cell reference of the active cell?, Formula Bar, Name Box, Which bar displays the value or formula in the active cell?, Formula Bar, Status Bar, What software is used to organize numbers and perform calculations in worksheets?, MS Word, MS Excel, Which feature is used to keep the top row visible while scrolling?, Freeze Top Row, Freeze First Column, A fill handle is used to, Copy data or formulas to adjacent cells, Delete cell contents, Which Excel chart uses vertical bars to represent data?, Column Chart, Pie Chart, Which Excel feature allows formatting cells based on rules or conditions?, Conditional Formatting, Color Picker, What is the correct formula to compute the total number of books in cells B3 to B6?, =SUM(B3:B6), =SUM(B3+B4+B5+B6), Excel interprets A1:C8 as, A1 times C8, A range of cells from A1 to C8, Which type of chart in MS Excel uses a pie to represent data?, Pie Chart, Line Chart, Which feature allows you to quickly summarize your data?, Subtotal feature, Deleting rows, Which feature allows you to illustrate data graphically to compare trends?, Chart, Text, Which feature sorts data in a selected range of cells only?, Sort range, Sort sheet, A fill handle is used to, Copy data or formulas to adjacent cells, Delete cell contents, This feature improves the look of your workbook and makes data easier to use and organize., Table, Name

Review

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?