Question 1

autofit column D to best fit the data

Accepted Answer

you doubled clicked Ds right border

Question 2

apply accent 1 cell style to the selected cell

Accepted Answer

in the home ribbon tab in the styles ribbon group you clicked the cell styles button. in the cell styles menu, you selected the accent 1 option

Question 3

delete this row

Accepted Answer

in the home ribbon tab in the cells ribbon group you clicked the delete button arrow. in the delete menu, you clicked the delete sheet rows menu item

Question 4

use format painter to copy the formatting from cell D1 and apply it to cell E1

Accepted Answer

in the home ribbon tab in the clipboard ribbon group you clicked the format painter button. you clicked cell E1

Question 5

merge the cells so the text appears centered across the merged cells

Accepted Answer

in the home ribbon tab in the clipboard ribbon group you clicked the merge and venter button arrow. Im the merge and center menu you clicked the merge and center menu item

Question 6

cut cell B7 and paste it to cell E12

Accepted Answer

in the home ribbon tab in the clipboard ribbon group you clicked the cut button. you clicked cell E12. in the home ribbon tab in the clipboard ribbon group, you clicked the paste button arrow. in the paste menu, you clicked the paste (P) button

Question 7

copy cell F3 and paste to cell F2

Accepted Answer

in the home ribbon tab in the clipboard ribbon group you clicked the copy button. you clicked cell F2. in the home ribbon tab in the clipboard ribbon group, you clicked the paste button arrow. in the paste menu, you clicked the paste (P) button

Question 8

use autosum to enter a formula in the selected cell to calculate the total off all the contiguous cells above

Accepted Answer

in the home ribbon tab in the editing ribbon group you clicked the autosum button. you pressed enter

Question 9

use autofill to copy the formula and formatting in cell E2 to cells E3:E6

Accepted Answer

you clicked and dragged the cell E2 fill handle, released the mouse button on cell E6

Question 10

insert a column to the left of the selected cell

Accepted Answer

in the home ribbon tab in the cells ribbon group you clicked the insert button arrow in the insert menu, you clicked the insert sheet columns menu item

Question 11

change the zoom level for the worksheet to be 110%

Accepted Answer

you clicked the zoom in button

Question 12

modify the number format so no decimal places are visible after the decimal point

Accepted Answer

in the home ribbon tab in the number ribbon group you clicked the decrees decimal button, clicked the decrease decimal button

Question 13

add a footer that displays the page number in the center section

Accepted Answer

in the design ribbon tab in the header and footer elements ribbon group you clicked the page number button

Question 14

cell F4 has been copied. paste the formula only into the selected cell (cell F5). do not include the cell formatting

Accepted Answer

in the home ribbon tab in the clipboard ribbon group you clicked the paste button arrow. in the paste menu you clicked the formulas (F) button

Question 15

center the content in the selected cells horizontally

Accepted Answer

in the home ribbon tab in the alignment ribbon group you clicked the align center button

Question 16

apply bold and italic formatting to the selected cell

Accepted Answer

in the home ribbon tab in the front ribbon you clicked the bolt button, clicked the italic button

Question 17

enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6

Accepted Answer

you clicked cell B7, typed =SUM(B2:B6) in cell B7 and pressed enter

Question 18

add a new worksheet to the left of the Dec 18 sheet

Accepted Answer

in the home ribbon tan in the cells ribbon group you clicked the insert button arrow in the insert menu you clicked the insert sheet menu item

Question 19

Modify the Dec 18 worksheet so gridlines will print

Accepted Answer

in the page layout ribbon tab in the sheet options ribbon group you checked the print check box

Question 20

ise a single command to clear everything (content and formatting) from the selected cells

Accepted Answer

in the home ribbon tab in the editing ribbon group you clicked the clear button. in the clear menu, you clicked the clear all menu item

Question 21

arrange all open workbooks in a single window so they overlap in a staggered diagonal pattern

Accepted Answer

in the view ribbon tab in the window ribbon group you clicked the arrange all button. inside the arrange windows dialog, you selected the Cascade Radio button, clicked the OK button

Question 22

delete the timesheets worksheet

Accepted Answer

in the home ribbon tab in the cells ribbon group you clicked the delete button row. in the delete menu you clicked the delete sheet menu item. inside the Microsoft excel dialog you clicked the delete button

Question 23

modify the worksheet so the first row is always visible when you scroll the worksheet down

Accepted Answer

in the view ribbon tab in the window ribbon group, you clicked the freeze panes button. in the freeze panes menu, you clicked the freeze top row menu item

Question 24

without adjusting the column widths, guarantee that all columns will print on one page

Accepted Answer

you opened the backstage view, clicked the print navigation button and clicked the scaling button. in the scaling menu, you clicked the fit all columns on one page menu item

Question 25

apply the accounting number format to the selected cells

Accepted Answer

in the home ribbon tab in the number ribbon group you clicked the accounting number format button arrow, clicked the accounting number format button

Question 26

use the spelling checker to find and change all instances of any misspelled words

Accepted Answer

in the home ribbon tab in the editing ribbon group, you clicked the sort and filter button, clicked the sort and filter button. in the review ribbon tab in the proofing ribbon group yo licked the spelling button. inside the spelling:English (United States) dialog, you clicked the change button. inside the Microsoft excel dialog you clicked ok button

Question 27

select cells A5:D8

Accepted Answer

you clicked cell A5, selected the cell range A5:D8

Question 28

change font size for the selected cells to 18

Accepted Answer

in the home ribbon tab in the font ribbon group you clicked the font size drop down arrow. in the font size menu you selected the 18 pt font size

Question 29

wrap the text in the selected cell

Accepted Answer

in the home ribbon tab in the cells ribbon group, you clicked the format button. in the home ribbon tab in the alignment ribbon group you clicked the wrap text button

Question 30

remane sheet1 Dec 26

Accepted Answer

you right clicked the sheet1 tab. in the tab right click menu you clicked the remake menu item. you typed Dec 26

Chapter 1 Simnet

Unlock all answers in this set

Haven't found what you need?