Which of the following options in Backstage View contains the command to change the file type of a saved file?, Export, Info, New, Publish, Which of the following groups on the Home tab contains the commands to insert delete and format cell width and height?, Number, Styles, Cells, Editing, Which tab on the Ribbon contains the function library?, Home, Inserts, Page Layout, Formulas, Which view should be used if you want to see where page breaks will occur in a worksheet?, Normal View, Page Break View, Page Layout View, Synchronous View, Which of the following keyboard shortcuts should be pressed to hide the columns which are selected in a worksheet?, Control 7, Control 8, Control 9, Control 0, Which of the following is a temporary storage area where all cut and copied items are stored?, Formula bar, Name box, Clipboard, Workbook, Which group on the Home tab contains the command for changing the fill color of a cell?, File, Font, Alignment, Editing, Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?, Cut Painter, Copy Painter, Paste Painter, Format Painter, Which of the following can be used to locate data in a particular column?, VLOOKUP, HLOOKUP, CLOOKUP, RLOOKUP, Which of the following can be used to locate data in a particular row?, VLOOKUP, HLOOKUP, CLOOKUP, RLOOKUP, Which of the following tabs contains the command to create a PivotTable?, File, Home, Insert, Page Layout, Which of the following areas in the PivotTable Field list task pane should you place numerical values to be summarized?, FILTERS, VALUES, ROWS, COLUMNS, Brian wants to apply a different chart style to his PivotChart. Which of the following PivotChart Tools tabs should be used?, Analyze, Format, Styles, Design, Which of the following adds the values in cells A1 through A10?, =SUM(A1:A10), =SUM(A1,A10), =SUM(A1!A10), =SUM($A1$A10), Alex wants to find the highest value in a range of cells. Which of the following functions should he use?, =MIN( ), =AVERAGE( ), =MAX( ), =MEDIAN( ), Which icon in the Function Library should be clicked to add the NOW function?, AutoSum, Date & Time, Lookup & Reference, More Functions, Which of the following is a type of equation which returns a value such as TRUE or FALSE?, Argument, Expression, Nest, Control, Carlos needs to combine words in a First Name and a Last Name column. Which of the following functions should he use?, IF, MIN, MAX, CONCATENATE, All formulas must begin with which of the following symbols?, Equals sign (=), Ampersand (&), Plus sign (+), Period (.), Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiplies the sum by 10. Which of the following formulas should he enter?, +A1+B1*10, .A1+B1*10, =(A1+B1)*10, &(A1+B1)*10, Which of the following types of cell references should you use if you want the cell references in the formula to change to reflect the position of its copied location relative to its original location?, Absolute, Mixed, Relative, Stationary, José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?, Delete the formula and just enter the value he wants in the cell, Resize the cell to fit the contents, Clear the formatting on the cell, Filter the cell, Which of the following groups on the Formulas tab contains the ability to turn on Formula view?, Function Library, Defined Names, Calculations, Formula Auditing, Which of the following groups on the Home tab contains the command to insert a worksheet?, Cells, Font, Alignment, Number, Which of the following keys can be pressed while dragging a worksheet to another location in the workbook to copy it?, Shift, Enter, Control, Spacebar, Which of the following appears around cells which have been copied?, Stationary blue and white dotted lines, Moving red and white dotted lines, Moving green and white dotted lines, Stationary red and white dotted lines, Which of the following is NOT a method of changing the height of a row?, Dragging the bottom border of the row to a different location, Selecting the row and pressing the up arrow, Clicking the Format icon and choosing the Row Height option and changing the height, Clicking the Format icon and choosing the AutoFit Row Height option, Karl wants to change the page orientation of the printed worksheet. Which group on the Page Layout tab contains the command to complete this action?, Themes, Scale to Fit, Sheet Options, Page Setup

Microsoft Excel Unit 1-6

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?