Questions LLC
Login
or
Sign Up
Ask a New Question
Microsoft Excel
Page 5
Questions (269)
How does using a table in Excel differ from using a range of cells?
Using a table in Excel provides a higher level of data
1 answer
asked by
mxolisi
22 views
What is the purpose of the "Display as Icon" option in the Insert Object dialogue box?
It makes the object visible only as a
1 answer
asked by
mxolisi
12 views
What happens to the rows that do not meet the filter criteria when applying a filter in Excel?
They are hidden from view
1 answer
asked by
mxolisi
10 views
Which is NOT a way to edit a formula in a cell in Excel ?
Right-click the cell and select Edit. Double-click the cell Select the
1 answer
asked by
mxolisi
10 views
When you lock cells in Excel, what happens to the locked cells when you protect the worksheet?
They become hidden and cannot be
1 answer
asked by
mxolisi
16 views
How can you edit an inserted object in Excel?
Double-click the object to open the external application. Use the "Edit" tab in the
1 answer
asked by
mxolisi
15 views
What is the purpose of the "Display as Icon" option in the Insert Object dialogue box?
It enables you to rotate the object. It
1 answer
asked by
mxolisi
8 views
Which option allows you to set or change the password for unlocking cells in Excel?
Cell Styles Format Cells Protect Workbook
1 answer
asked by
mxolisi
12 views
What is the Function Builder in Excel used for?
To analyse and interpret data in a range of cells To guide users in constructing
1 answer
asked by
mxolisi
11 views
What does the "Chart Layouts" option in Excel allow you to do?
Modify the chart's title and axis labels Adjust the spacing and
1 answer
asked by
mxolisi
22 views
Which option in Excel allows you to specify the data source and import settings when importing data from an external file?
Power
1 answer
asked by
mxolisi
19 views
How can you modify the appearance of a chart in Excel?
By changing the font size of the chart title By resizing the worksheet
1 answer
asked by
mxolisi
19 views
Ivan types the following into a cell: “10/5.” What would appear in an Excel cell? (1 point)
A. 10/5 B. 2 C. 5-Oct D. !ERROR#
1 answer
asked anonymously
13 views
Which of the following represents a range of cells? (1 point)
A. B4:F4 B. B4, F4 C. B4-F4 D. B4/F4
1 answer
asked anonymously
12 views
Group the January, February, and March worksheets, then in cell C12 on the January worksheet, use the AutoSum button to total
1 answer
asked anonymously
12 views
In cell B5, enter a formula using defined names to subtract DirectCosts (cell B4) from Revenues (cell B3). In excel explain in
1 answer
asked anonymously
13 views
Assign the defined name FebruaryAttendance to range D4:D11. In excel explain in detail
1 answer
asked anonymously
6 views
Create defined names for range C3:E11 using the Create from Selection command. Use the titles in the Top Row of the selection as
1 answer
asked anonymously
10 views
How to Set the print area as range A2:C16. In excel explain
1 answer
asked anonymously
8 views
How to In cell E12, edit the defined name March by typing March Attendance as the new name. In excel
1 answer
asked anonymously
7 views
Where do you rename a workbook and adjust its save location?
A. Save As dialog box B. Home tab C. Name box D. Active cell
1 answer
asked anonymously
9 views
Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)
1 answer
asked anonymously
6 views
Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.
True False
1 answer
asked anonymously
8 views
If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as
1 answer
asked anonymously
9 views
Kai wants to hide a worksheet with a password to prevent other users from viewing it. To do so, he can Click Review > Protect
1 answer
asked anonymously
14 views
Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements. To do so, she can
1 answer
asked anonymously
13 views
To lock certain cells in a worksheet to protect them, select the cells, then click Home tab > Alignment group > Format Cells
1 answer
asked anonymously
11 views
How to Group the January, February, and March worksheets, then in cell C12 on the January worksheet, use the AutoSum button to
1 answer
asked anonymously
11 views
How to do this in excel Nadia wants to assign names to other cells to help her interpret the loan calculations. In the range
1 answer
asked anonymously
13 views
How to do this in excel 4. Nadia needs to calculate the monthly payment for the loan to fund the law firm's transition to the
1 answer
asked anonymously
12 views
How to do this In cell F7, enter a formula without using a function that adds the Loan_Amount to the Total Interest to determine
1 answer
asked anonymously
9 views
Cell D6 includes the rate a bank quoted Nadia for the business loan. In the list of interest rates (range C12:C26), create a
1 answer
asked anonymously
11 views
Nadia has set up the structure for an amortization schedule in the range H4:L15. Finish the amortization schedule by completing
1 answer
asked anonymously
17 views
Using the shown Microsoft Excel screenshot, respond to the following questions by clicking on the appropriate command.
HINT! This
1 answer
asked anonymously
3 views
Given the following screenshot taken from a workbook in Microsoft Excel.
(a) You want to create space to add column headings for
1 answer
asked anonymously
6 views
The line chart in the range H16:L33 compares the amount of principal and interest paid each year of the loan. Nadia wants to
1 answer
asked anonymously
9 views
Fill the series in range B4:F4 with a linear trend. In excel how to
1 answer
asked anonymously
6 views
How to Apply the Number format with 0 (zero) decimal places to the Column chart data labels, and then close the pane. In excel
1 answer
asked anonymously
5 views
Create and apply a custom format code to cells in range B3:D3 using the yyyy format. In excel
1 answer
asked anonymously
8 views
Create a custom cell style named Net Income based on the formatting in cell B15. Add Bold formatting to the new cell style;
1 answer
asked anonymously
5 views
Add the Sheet Name header element to the left header section, and the text Page followed by the Page Number header element to
1 answer
asked anonymously
10 views
To enter your name in the lower right corner of a worksheet page, you can
Use a button on the Header and Footer Tools Design tab.
1 answer
asked anonymously
11 views
To enter your name in the lower right corner of a worksheet page, you can
A Use a button on the Header and Footer Tools Design
1 answer
asked anonymously
9 views
Gilberto also wants to display the total accessory sales from the previous year. This data is stored in another workbook. In
1 answer
asked anonymously
12 views
Gilberto wants to make some changes to all five worksheets, which have the same structure.
Group the Annual Sales, Quarter 1,
1 answer
asked anonymously
8 views
How to do this in excel explain step by step In the range D5:D9 on all five worksheets, Gilberto wants to project next year's
1 answer
asked anonymously
12 views
Insert a table, with headers, using cells A3:E11 as the table range. How to do in excel
1 answer
asked anonymously
6 views
Insert a table, with headers, using cells A3:E11 as the table range. In excel
1 answer
asked anonymously
5 views
Remove duplicate records from all columns of the Workshop Costs table. How to do in excel
1 answer
asked anonymously
6 views
Add a new record to the end of the Workshop Participants table, entering the following data: type Gage in cell A15, type James
1 answer
asked anonymously
13 views
Pages
1
2
3
4
5
6
Parent Categories (28)
Computer Applications
Computer Programming
Computer Science
Computer Science and Technology
Computer Science/Information Technology
Computer Science/Software Programs
Computer Science/Tech
Computer Science/Technology
Computer Skills
Computer Software
Computing/Technology
Data Management
Microsoft Office
Microsoft Office Products
Productivity software
Software
Software and Applications
Software Applications
Software Development
Software Programs
Software Skills
Software Tools
Software/Application
Software/Application usage
Spreadsheet Programs
Technology
Technology and Software
Technology/Software