The Final
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas
$A$5
A jewelry designer creates an excel sheet to list different items he sold on the previous day. Cells A1, B1, C1, and D1 contain headings—Order ID, Unit price, and Quantity, respectively. Cells A2 to A6 list the order ID for items sold—10001,10002,10003,10004, and 10005, respectively. Cells B2 to B6 list their respective unit price—$15, $18.5, $12, $9.5, and $6. Cells C2 to C6 list their respective quantities—20, 32, 16, 15, and 10. If he enters the formula in cell D1 as: =VLOOKUP (10005, A1: H3, 3, FALSE), what will the formula return
10
How many actions does the Undo button let you reverse
100
What is the correct formula to insert the date January 12, 1998 into a cell?
=DATE(1998,1,12)
Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this
=HOUR(A1)
A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so
=ROUND(A5,2)
A new worksheet has items listed in cell range A1 to A20. Which of the following will you type in the Format Object window in the Input Range box to specify the range for the list?
A1:A20
Which of the following functions would you use to calculate the arithmetic mean of a price list
AVERAGE
In the formula =B6*$B$2, which of the following describes $B$2
Absolute cell reference
Which of these will you select as X in the following series of clicks to insert a hyperlink to a webpage: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Insert Hyperlink box > X > Type or paste link?
Address box
Marcos wants to refresh the data in a Pivot table manually. He clicks on the PivotTable to show the PivotTable Tools on the ribbon. Which combination of keys should he press next to complete the procedure?
Alt +F5
Arlo creates a rectangular shape and inserts the text 'Color Box' in it. Then, he right clicks on the shape and selects a button to assign a macro to it. Which of the following can his selection be?
Assign Macro...
Which of the following lets you fill a cell with only specific elements of a copied cell
Auto Fill Options button
To return cell contents to its default font and style, you can use the _____ command
Clear Formats
Horatio wants to hide field headers in a Pivot table to increase the display of the screen. He clicks on a cell in the pivot table, then clicks on ANALYZE in the ribbon. What should he do next to complete the procedure?
Click on Field Headers in the Show group.
Which of the following will you do to manually turn off autofilter in a table between the steps: Clicking any cell in the filtered range and clicking the Filter button?
Clicking the Data tab on the Excel Ribbon
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab
Color
Which of the following will you select as X in the series of clicks to add a color scale to a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > (select) Subtype ?
Color Scales
Which dialog box opens after selecting a cell in the list of prepared data, clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group?
Create Table
Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable?
Ctrl
Calista wants to add a screentip to a hyperlink she inserted into a cell. She selects the cell with the hyperlink, then presses a certain combination of buttons, then selects ScreenTip, types in a message, clicks OK, then clicks OK again to save the link. Which of these combination of buttons must she have pressed during this procedure?
Ctrl + K
Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?
Ctrl + Q
Which of the following will you click after File > Options to open the Developer tab to change the back color of an ActiveX control?
Customize Ribbon
Which of the following will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?
Customize Ribbon
Which of the following will you select as X in the series of clicks to circle invalid data in a worksheet: Data tab > Data Tools group > Arrow next to X > Circle Invalid Data?
Data Validation
Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?
Delete
Which of these keys will you press to remove a hyperlink completely?
Delete
Which of the following must be checked after selecting Main tabs from Customize the Ribbon drop down box, to turn the Design Mode on?
Developer
What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> OK?
Enter the desired size of the chart title in the Size box.
A predesigned combination of formats, such as font size and color, is called a cell default, True or False?
False
A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1 and E1 as Tree, Height, Age, Yield, and Height, respectively. He mentions the criteria ="=Mango", >10, ="Orange", >12 and <15 in cells A2, B2, A3, and B3, respectively. Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees, cells B4 to B10 with heading "Height" in B4 cell contain data for the height of trees, cells C4 to C10 with heading 'Age' in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield. He can use the formula: =DGET(A5:E10, "Yield", A1:E3) to extract the value of yield that matches the specified criteria. T or F
False
Alicia has already created a chart in Excel and wants to link it to her PowerPoint presentation. To do so, she can click Insert tab > Symbols group > Object command > (Dialog box > Create New > Locate desired file > Insert > OK > Tick box next to Link to file > OK, True of False?
False
Avril wants to link worksheet data to a Word document so that whenever the worksheet is updated, the changes are updated in the document. To do so, she should open the Excel worksheet and drag over the content and press Ctrl+C. Next she should move to the Word file, Place the insertion point where she wants the worksheet data to appear and press Ctrl + V, True or False?
False
Decreasing a cell's indent moves its contents to the right one space, True or False?
False
In formulas, calculations in square brackets are calculated first. True or False?
False
Ngabile wants to insert a Treemap chart for a data set. To do so, she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap, T or F?
False
To change the background color of a cell, you use the Background color button, True or False?
False
To find the largest value in a cell range, use the MIN function
False
To insert an option button into a worksheet, click on the following series: Developer tab > Insert > Form Controls > Image with a tick inside a rectangular box.
False
To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval, the formula: =MROUND(A4,0:30) can be used, True or False?
False
To search for an online picture in the Insert Pictures window, you enter a format related to your subject of interest, T or F?
False
When you change cell contents to italics, you are changing the cell's alignment, True or False?
False
When you copy cell contents, the data is removed from its original location and placed on the clipboard. True or False?
False
When you enter a value in a worksheet cell, it is automatically left-aligned. True or False?
False
You can press Ctrl+F11 to update a linked object from another app True or False?
False
Which of the following tabs lets you see exactly how your worksheet looks before printing
File
On which tab and button are document properties located for editing
File tab, Info Button
Marianna wants to add a border to a legend. Which of the following should she select as X in the following series of clicks to do so? Legend > (right click) Format legend > Legend Options > X > Border > Solid Line
Fill & Line
Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice?
Fill & Line
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell
Fill handle
Leigh-Ann wants to filter data in a PIvotChart using a slicer. She clicks on the table and then selects Slicer in a particular group on the insert tab. She then ticks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK. What tab did click during the procedure?
Filters
To enter a range of text based on examples that are already in your worksheet, which of the following can you use
Flash Fill
To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?
Gridlines View
Che wants to change the chart type of the whole chart to give it a different look. To do this, he follows the following steps: 1. X 2. He clicks Change Chart Type On the Design tab in the Type group. 3. Che clicks the chart type that he wants to use in the Change Chart Type dialog box. What was step 1 in his procedure?
He clicks the chart area of the chart.
You recieve a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is
Hidden
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Home
Which of these series of clicks would you select to remove hyperlink from a cell?
Home tab > Styles group > Delete > Remove Hyperlinks
Which of the following will you select as X in the given series of clicks to insert a 3-D pie chart: Insert > Charts group > X > 3-D Pie?
Insert Pie or Doughnut Chart
Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?
Insert Pie or Doughnut Chart
What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?
Insert tab
Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box) Show Data table?
Layout
Which of the following will you select as X in the given series of clicks to add a legend to the bottom of a chart: Chart > + sign > X > Bottom?
Legend
To have Excel enter the lowest price from a range of prices, which of the following would you use
MIN function
Kahir wants to delete a macro. To do this, he selects Tools > Macro > X > Select Macro > - sign > Yes on confirmation message dialog box. Which of the following will he select as X in this series of selections?
Macros
To combine multiple cells into one combined cell, which of the following do you use
Merge and Center button
After drilling down, Esteban wants to drill up to analyze summary data. To do so, he follows the following steps: 1. Select the item to drill up on in the PivotTable hierarchy you have drilled into. 2. Click the Quick Explore button that appears in the lower-right corner of the selection. 3. Use the Quick Explore button to reach the data you want. Which step did he miss while following this procedure?
Not :Step 2: Select the item you want to drill up on and then click Drill Up.
Which of the following will you do to reapply a filter to a table after the steps: Selecting any cell in the filtered table and clicking the Data tab?
Not Clicking Subtotal in the Outline group, Maybe Clicking Reapply in the Sort & Filter group
What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style?
Not Data, It is Insert tab
Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles?
Not Format as Table, Maybe Conditional Formatting
Which of these tabs will you select to alter the font as desired while changing the slicer style?
Not Slicer Contextual tool tab, maybe Analyze tab
Which of these combination of keys will you click to clear an outline?
Not Worksheet > Data tab > Outline group > Ungroup > Ungroup > Rows > OK, Maybe Worksheet > Data tab > Outline group > Ungroup > Clear Outline
Which of the following combinations of keys will you press to open the VBA window and run a macro code?
Not: Alt + F9
Portia wants to create a calculated measure in Excel. To do this, she creates a PivotChart report using the data stored in an Analysis Services cube. Next, she clicks on a tab "A" and then in group "B," she chooses OLAP Tools > MDX Calculated Measure to open the New Calculated Measure dialog box. What can A and B be in the procedure?
Not: A—Design tab, B—Data group
Which of the following should be selected as X in the series of clicks to insert a check box (form control) into a worksheet: Developer tab > Controls group > Insert > Form Controls > X?
Not: Button image with a tick inside a rectangular box
Which of these steps will you choose to refresh data in a Pivot Chart?
Not: Click on the Pivot Chart > PivotTable Tools > Analyze > Refresh arrow > Refresh Status
Nolan wants to group data in a Pivot table to analyze a subset of data. Which of these series of clicks/ selections/ entries should he follow to do so?
Not: Ctrl + values > Group
In which of these boxes will you list all the possible fields that can be included in your formula in a PivotTable?
Not: Formula text box
Chastity wants to rename her pivot table from PivotTable1 to ProductData. She clicks the Pivot table then goes to PivotTable Tools > Analyze, and clicks the X text box in the PivotTable group. She then types a new name and presses ENTER. What can X be in the procedure?
Not: Pivot Chart Name
Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she select in the Protect Workbook box under Options in the File tab to do this?
Not: Protect Current Sheet
How can one filter a PivotTable using a report filter?
Not: Right-click a cell in the pivot table, and click Pivot Table Options, then set the 'Display Fields in Report Filter Area' to Over, Then Down' On the Layout & Format tab.
Edwin wants to insert a Pivot Chart to summarize raw data. Which of the following combination of clicks/selections/entries should he use to do this?
Not: Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK
Jin wants to insert a recommended pivot table. He clicks a single cell inside the data set, then proceeds to step X and finally clicks OK in the dialog box that appears after step 2. What can step 2 be?
Not: Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab.
Ariana wants to view data from two workbooks at the same time so that one of them opens in a new window. What can she click to display one workbook in a new window?
Not: View tab > Window group > Arrange All
To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do
Open the workbook, make changes, and then save it using a different name.
Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use
Page Layout
To which of the following chart types can you not add axis titles?
Pie chart
Bella wants to insert a hyperlink to a location in the current file. Which of these can be X in the following series of clicks she can use to solve her purpose: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Link To > X > Select heading (current document only), bookmark, slide, custom show, or cell reference to link to in the list?
Place in This Document
Which of the following properties is used to specify the way the control is attached to the cells below it, while inserting a command button (ActiveX control) into a worksheet?
Placement (Excel)
Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?
Remove
Grace wants to connect a slicer to two PivotCharts. In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK?
Report Connections, Insert Slice, Maybe Remove
Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet. Which of the following series of clicks will help her do so?
Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes
Where do you rename a workbook and adjust its save location
Save As Dialog box
Tim wants to insert a hyperlink to a new file for quick access to related information on a web page. Which of these can be X in the following series of clicks he can use: Cell to insert hyperlink > Insert tab > Links group > Hyperlink > Link to > Create new Document > Name of New Document (Type a name for new file ) > When to Edit > Select an option > Text to display box > ( Type text that you want to use to represent the hyperlink) > X > (Type information to be displayed when pointer rests on hyperlink in the box) > OK?
ScreenTip Text box
Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?
Shape Fill
Mila wants to digitally sign a workbook to communicate that no further modifications should be made in the workbook. She clicks Insert tab > Text group > X > Microsoft Office Signature Line > Signature Setup Dialog box > Type Information for each box in the dialog box > Show sign date in signature line OK. What can X be in this series of clicks?
Signature line List
Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?
Style
Which of the following keys will you press when the cell cursor is in the last cell of the last record (row) to add new data for the next record?
Tab
Which of the following is true when you copy and paste formulas using the fill handle
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
Which of the following is true when you copy and paste formulas using the fill handle?
The AutoFill Options button lets you fill cells with specific elements of the copied cell.
Which of the following is true about deleting a worksheet row
To delete a row, toy can select the row, then use the delete button in the Cells group
Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?
Total Row
A manager creates data for cost of products of the firm he works for. He enters headings in cells A1, B1, C1 and D1 as Order ID, Quantity, Unit Cost and Total Cost respectively. He mentions the criteria >1000 and >=5 in cells A2 and B2 respectively. Cells A3 to A10 with heading "Order ID" in A4 cell contain data for the order IDs, cells B3 to B10 with heading "Quantity" in B3 cell contain data for quantities for each order ID, cells C3 to C10 with heading "Unit Cost" in C3 cell contain data for unit cost of each order ID and cells D3 to D10 with heading "Total Cost" in D3 cell contain data for total cost of each order ID. He can use the formula: =DCOUNT(A4:D10, "Unit Cost", A1:B2) to count the occurrences that meet the conditions in A1:B2. T or F
True
A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1, and E1 as Tree, Height, Age, Yield, and Height respectively. He mentions the criteria ="=Mango", >10, ="Orange" and <15 in cells A2, B2, A3 and E2 respectively. Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees, cells B4 to B10 with heading "Height" in B4 cell contain data for the height of trees, cells C4 to C10 with heading "Age" in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield. He can use the formula: =DCOUNTA(A5:D10, "Yield", A1:E2) to count the rows containing Mango in column A with a height >10 and <15. T or F
True
A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell, True or False?
True
A teacher creates a table that contains data about winners of a Sports Day events in 4 columns, A to D under headings : Event, Rank, First name, Last name and Grade, respectively. To sort the table by Event and then by Rank, she can select a cell in the column A, select the Data tab on the Ribbon, then select the Sort command. Under the Sort dialog box, in the Sort by drop down menu, she can select Event, click Add Level and then select Rank in the Then by drop down menu and finally click OK, ,True or False?
True
A teacher creates a table that contains data in three columns, A to C under headings : First name, Last name, and Date of birth, respectively. To sort the table by the last names of students from A to Z, she can select a cell in the column B, select the Data tab on the Ribbon, then click the Ascending command,True or False?
True
A worksheet has the following data in it: Cell range A2 to A10 in column A lists the years from 2010 to 2019. Cell range B2 to B10 in column B lists the types of food items sold during each year: Tomatoes, Oranges, Pears, Pineapples, Potatoes, and Onions. Cell range C2 to C10 in column C lists the sale of each item in each year. If we insert the formula =COUNTIFS("=Onions","B2:B10") in cell A11, it will give us the count of the number of times "Onions" has been listed in the worksheet.
True
Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline Tools > Design > Style (choose a style), T or F?
True
Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart, T or F?
True
Jack wants to insert a Win/Loss sparkline in Excel. To do this, he can click on the cell he wants to insert a Sparkline in, then click Insert tab, select Win/Loss Sparkline from the Sparklines group, insert the Data Range and then click OK, T or F?
True
Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5, True or False?
True
Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5), True or False?
True
Katrin has created a new table with only data for sale of products in the East region of her company. She wants to change the pivot table showing the sale of products in both East and West regions of the country to use that source, so that it can be sent to a manager in the West region, without revealing the East region's data. To do so, she can follow the following series of clicks/ entries/ selections: Cell > PivotTable Tools tab > Data group > Top section of the Change Data Source command > Change PivotTable Data Source dialog box > Select a new data source range > OK.
True
Nadine wants to insert a sparkline in Excel using the Quick Analysis tool. She can do this by selecting the data for which she wants to add Sparklines, then in the empty column to the right side of the data click the Quick Analysis button, click Sparklines and select the type of Sparkline she wants, True of False?
True
Ned wants to calculate the total sale of a product during quarters 3 and 4 of a financial year. He creates a table of quarterly sales of different products o the company in different regions. In the table, cells B1 to B20 with heading "Quarter" list the quarters of the years I to IV, cells C1 to C20 with heading "Product" lists the different products and cells D1 to D20 with heading "Sales" list the sales amount for each quarter and product in dollars. The criteria specified—Quarter and Product are in cells H5 and I5 and their values >3 and Balloons respectively are mentioned in cells H6 and I6. To calculate the total sale of a particular product, he can use the formula =DSUM(B1:D20,"Sales",H5:I6). T or F
True
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK, T or F?
True
One can rearrange fields in the PivotTable by clicking the field name in one of the areas, and then selecting Move Up command to move the field up one position in the area.
True
One can select the macro one wants to edit in the Macro Name box.T or F
True
One can use the areas section (at the bottom) of the Field List to rearrange fields the way they want by dragging them between the four areas.
True
Pam wants to break the link to the external reference of a formula so that all its values are replaced by the calculated values. To do so, she can click Data Tab > Queries & Connections Group > Edit Links button > Edit Links dialog box > Break Link button, True or False?
True
Salena has created a chart to show the sale of products of her firm in different cities during different years. The chart has only one series with all the columns of the same color. The Year and Location fields are both in the Rows area. Now, she wants to create columns with different colors, for which she will have to move one of the fields into the Column area in the PivotTable Field List. To do so, Salena can follow the following series of clicks/ entries/ selections to do so: Pivot Chart > Pivot Chart Field window > Drag the Year field from the Axis box (Categories) to the Legend (Series) box. This will create a series for each city, and show the city's columns in a different color.
True
Soledad wants to create an auto outline in a Excel worksheet to hide details and only show the headers. To do this, she can click into any cell, then click Data tab > Group > Auto Outline, True or False?
True
The manager of a footwear company creates a table that contains data in three columns, A to C under headings: Names of customers, Date of order, and Size of footwear ordered, respectively. To select a separate table to sort the number of footwear that were ordered on different dates, she can select the cell range she wants to sort, select the Data tab on the Ribbon, then click the Sort command. In the Sort dialog box that appears, she can choose the column she want to sort by, decide the sorting order and click OK.
True
To add a calculated field to a PivotTable, select a cell in the pivot table, then under the PivotTable Tools tab, click the Analyze tab. In the Calculations group, click Fields, Items, & Sets, and then click Calculated Field. Enter a name for the calculated field, type a formula in the Formula box, then click Add to save the calculated field, and click Close.
True
To add fields to a PivotTable, one can use the field section of the Field List and tick the box next to field names to place them in the default area of the Field List.
True
To apply banded rows to a table, we can select the range of cells that we want to apply banded rows to, then click on the following: Insert tab > Table > OK in Create table dialog box > Design tab > Table Styles Options group > Check Banded rows box ,True or False?
True
To change theme effects, click on Effects on the Page Layout tab, then select the set of effects that you want to use
True
To change theme effects, click on Effects on the Page Layout tab, then select the set of effects that you want to use, True or False?
True
To clear all the data from a PivotChart, click the PivotChart. Then on the Analyze tab, in the Data group, click Clear, and then click Clear All.
True
To collapse data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > + sign,True or False?
True
To delete duplicate records from a table, select the range of cells, then click Remove Duplicates on the Data tab in the Data Tools group, then select one or more columns under Columns. Click OK, and then click Ok again to dismiss a message that indicate the number of duplicate values removed or how many unique values remain, True or False?
True
To delete duplicate records from a table, select the range of cells, then click Remove Duplicates on the Data tab in the Data Tools group, then select one or more columns under Columns. Click OK, and then click Ok again to dismiss a message that indicate the number of duplicate values removed or how many unique values remain.
True
To display the PivotTable Field list, right-click any cell in the pivot table and select Show Field List from the menu.
True
To edit an embedded object such as an Excel spreadsheet in its source application, double-click the drawer ID of the appropriate drawer in the Folders window, then double-click the folder containing the Excel spreadsheet, highlight it, choose Object > Edit Object to enter edit mode and make desired changes in it, T or F?
True
To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER, True or False?
True
To filter data in a PivotTable, follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.
True
To group specific rows in Excel, select them, then click the Group command on the Data tab in the Outline group. Finally select Rows or Columns in the Group dialog box and click OK,True or False?
True
To hide the PivotTable Field list, right click on any cell of the pivot table, and select Hide Field List option from the context menu.
True
To insert WordArt in Excel, click on Insert > WordArt, then select the WordArt style and then replace with the desired text in the Placeholder text. T or F
True
To insert a Scatter chart for a data set, we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y) or Bubble Charts > Scatter > Chart of choice > OK, T or F?
True
To insert a trendline that forecasts future trends into a chart, we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box, T or F?
True
To insert an equation, click on the Object in the Text group on the Insert tab, then click Microsoft Equation 3.0 in the Object type box, and then click OK, True or False?
True
To insert the current date in cell B1, type CURRENT DATE in cell A1 and =NOW() in cell B1 and press ENTER, True or False?
True
To move a chart to a different worksheet, click on the Chart > Chart Tools > Design tab > Location group > Move Chart > New sheet, and then in the New sheet box, type a name for the worksheet, T or F?
True
To move a chart to another location on the sane worksheet, drag it to the location you want, True or False?
True
To open the macro dialog box for editing a macro in Visual Basic Editor, press Alt+F8. T or F
True
To remove a field, in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.
True
To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button, True or False?
True
To remove duplicate values from an Excel worksheet, click Data > Data Tools > Remove Duplicates,True or False?
True
To remove duplicate values from an Excel worksheet, click Data > Data Tools > Remove Duplicates.
True
To save a workbook for the first time, you use the Save As dialog box
True
To see the data source for the selected chart, click the Design tab, then under PivotChart Tools click Select Data to open the Select Data Source window.
True
To show formulas instead of values, click on the formulas tab in the ribbon, then in the formula auditing group, click on the show formulas option. True or False?
True
To switch chart rows and columns, we can click anywhere in the chart containing the data series that we want to plot on different axes, click on the Design tab in Chart Tools, then in the Data group, and finally click Switch Row/Column, T or F?
True
To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab. In the Group dialog box, select Rows and click OK ,True or False?
True
To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets, True or False?
True
To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.
True
To unprotect a workbook, open the Excel file, then click on File > Info > Protect Workbook > Encrypt with Password > OK. T or F
True
Tomoko has created a table for the sale of sweatshirts in her shop last month with the headings, Customer's Name, Sweatshirt Size, Order ID and Payment Date. She wants to sort the number of sweatshirts of each size -Small, Medium, Large and Extra Large, bought by different customers. To do so, she can first sort her worksheet by sweatshirt size from smallest to largest, then click Subtotal command under the Data tab. Tomoko can then click the drop-down arrow for the At each change in field and select 'Sweatshirt Size', then select COUNT to count the number of sweatshirts ordered in each size. Then she can select 'Sweatshirt Size' in the Add subtotal to field and finally click OK.
True
When we add fields to the Column Labels area of a Pivot Table, they appear as headings on the left of the table.
True
You can edit cell contents in the formula bar or in the cell itself. True or False?
True
You can repeatedly paste an item from the Office Clipboard as many times as you like, True or False?
True
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. True or False
True
You can use the DELETE key to clear cell contents, True or False?
True
Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?
Uncheck (Select All), select the box beside the number 60 and click OK.
How can you remove data labels from a chart?
Uncheck the box beside Data Labels in Chart Elements.
Which of the following would you select on the Developer group to record a relative reference macro?
Use Relative References
Don wants to compare two worksheets in the same workbook by viewing them side by side. What can he click to do so?
View tab > Window group > New Window > View tab > Window group > Arrange All
Sala wants to unfreeze the first column of his worksheet. Which of the following series of clicks will help him do so?
View tab > Windows group > Freeze Panes > Unfreeze Panes
Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek... from the drop down menu. What is X in the procedure
What-if Analysis
Mila wants to restrict a cell to accept only whole numbers between 1 and 100. What should she select as X in the following clicks/entries/selections: Select cell. Data > Data Validation > Settings tab > Validation Criteria > Allow > X > Data > (select) between > Minimum > (select) 1 > Maximum > (select) 10 > OK > Enter number between 1 and 100 in cell?
Whole number
Igor wants to set margins for a worksheet he has created per his choice. Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top, Header, Left, Right, Bottom and Footer text boxes > OK?
X- Margins, Y- Custom Margins
Kylie is a corporate trainer. She creates a table with three columns, with column headings as: Skill Number, Skill Name and Learning Objective. She wants to display numbers in the first column in the range of 400 to 500. What can Kylie select as X and Y in the following series of clicks or entries to do so: Click filter icon on the column heading > X > Y > (Enter value 400 in dialog box on top) > (Enter value 500 in dialog box below it) > OK?
X-Number Filters, Y-Between
To illustrate different data levels using small graphics representing values, which of the following can you use?
icon sets
Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?
maybe reset window position, Arrange All
Dante wants to calculate the currently monthly subtotals for the sales of golf balls in his store. Which of the following will he select as X in the series of clicks to do so: Cell in the range > Data > X > Subtotal > OK?
not Connections, Maybe Data Tools
A workbook template has which of the following file extensions
not xslx. xlsx
What is the file extension of macro-enabled workbook?
xlsm
