63 Best Microsoft Excel Questions and Answers (Q&A) - ProProfs Discuss

What program consists of a grid made from columns and rows?

Cynthia Williams
Answered: Jul 17, 2018

1. C 18. The division function divides 2. A 19. Columns and Rows 3. B 20. R...Read More

4 Answers

1068 views

What is defined as the horizontal space that is going across the window in a spreadsheet?

M. Klose, Content Writer
Answered: Oct 16, 2018

The answer to this is a row. If it is the vertical space that would need to be defined, that will be called column. Microsoft Excel is actually very useful for a lot of people. There are a lot of...Read More

3 Answers

1017 views

What would the formula "Sheet1! D9+Sheet1!E9" do in Microsoft excel?

Octara
Answered: Apr 25, 2024

This would select D9 and E9 and add the two together from sheet1

1 Answer

882 views

What is MS-Excel based on?

N. Kingsley, Writer
Answered: Jul 17, 2018

MS-Excel is based on windows. Windows originally introduced a number of signature apps. Among word and PowerPoint, the MS-excel was also a necessity for maintaining day to day work. Whether it...Read More

3 Answers

859 views

What is the group of cells that form a rectangle on the screen called?

Ali Mubwembe
Answered: Apr 26, 2018

Group of cells that form a rectangle on the screen called Range.

2 Answers

833 views

Which formula would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?

E. Stanley, Technical writer
Answered: Apr 24, 2019

The correct answer to this question is =SUM(J1:J8). The Sum function is a popular feature of Microsoft Excel, which is a spreadsheet software by Microsoft. It is a function for math and trig. It...Read More

3 Answers

784 views

What happens when dollar signs ($) are entered in a cell address?

John Smith
Answered: Apr 25, 2024

An absolute cell address is created.

1 Answer

747 views

What is the difference between filter and sort?

Tjz
Answered: Apr 25, 2024

Filtering hides data as well as can sort

1 Answer

692 views

What would be the most efficient way to format several cells with a specific font, number format, alignment, font color?

Vlam
Answered: May 20, 2020

This question is definitely subject to interpretation. The table feature uses a broad range of cells that follow a rectangular pattern. Format painter allows the selection of irregular patterns...Read More

3 Answers

671 views

What are the two common wildcard characters that Excel recognizes?

L. Brett, Sales Manager
Answered: May 29, 2019

Excel is a program on the computer to organize numbers on a spreadsheet. There are many different features in Excel, including sorting and using formulas to create numbers into a large number of...Read More

3 Answers

663 views

What is the function of the word =SUM at the beginning of an Excel spreadsheet formula?

John Smith
Answered: Apr 25, 2024

To add all the data together using addition only

1 Answer

626 views

What does autosome do in Excel?

John Adney
Answered: Aug 05, 2017

The answer is d for the above question

plase let me faast

2 Answers

619 views

What does the statement do?

E. Barnes, Professional Gamer
Answered: May 02, 2019

The correct answer to this question is Deletes Entire Rows from 1 to10 in the worksheet Data. This action would occur in Microsoft Excel. The code used to delete the rows is a visual basic...Read More

2 Answers

597 views

Which formula would you use to add the all the numeric data in a range of cells, ignoring those which are not numeric in MS-Excel?

PRST_GY
Answered: Apr 25, 2024

Sum

1 Answer

577 views

What button should be pressed to complete cell entry?

F. Ray, Student
Answered: Oct 11, 2018

Accountants and bookkeepers use Excel spreadsheets often due to their line of work. When typing in information into the cells of the Excel spreadsheet, they usually type it in fast because they...Read More

3 Answers

568 views

Microsoft Excel Questions and Answers (Q&A)

Related