basic excel exam | questions and answers 2023/24

basic excel exam | questions and answers 2023/24 Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before? - Ribbon What is represented by the small, black square in the lower-right corner of an active cell or range? - Fill handle Which of the following is one way to change column width to fit the contents? - Double-click the boundary to the right of the column heading. If you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to: - Click Wrap Text If cells are: A1=90, A2=85, A3=80, A4=75, and A5=75. What will be your formula if you are going to get the average? - =AVERAGE(A1:A5) You can complete the entry of a cell formula that contains cell references by pressing _______. - Enter key Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell? - Sum A fast way to add up this column of numbers is to click in the cell below the numbers and then: - Click the AutoSum button on the Standard toolbar, then press ENTER. Which menu option can be used to split windows into two? - View -> Split q ###### in a cell means: - The cell is not wide enough. If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next? - Click the arrow on the Paste button on the Standard toolbar, then click Values. An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. - True To select several cells or ranges that are not touching each other, you would _____ while selecting. - Hold down the CTRL key A Formula and a function are the same thing. - False Once data is entered into a cell, can it be edited after saving the file? - Yes, even after saving the file, double click on the cell where data is to be changed to edit. To add a new row, click a cell in the row immediately above where you want the new row, right click, select insert and press enter. - False Which is not the function of "Edit, Clear" command? - Delete cells An Excel Workbook is a collection of _______. - Worksheets In EXCEL, you can sum a large range of data by simply selecting a tool button called _____? - Autosum =FUNCTION(argument1,argument2, ...) is ________. - The general syntax of all functions. What is the function of the autofit? - Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font What is the result of the following formula: =(5-3)^2/1*2? - 8 What happens when dollar signs ($) are entered in this address, $B$2:$B$10? - The ra