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

What group of cells form a retangle on the screen?

J. Shatner, Content writer
Answered: Jan 04, 2019

In Excel, a person can type in information in each cell. Then the person can sort the information. Also, instead of inputting data into each square, the person can see if there is a pattern among...Read More

2 Answers

562 views

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

Chris Kenway, Content Writer
Answered: May 02, 2019

The correct answer to this question is C, Pie Chart. A pie chart is a graph in the shape of a circle. Data or statistics are divided into slices and each slice represents a number. It is called a...Read More

2 Answers

546 views

How many worksheets does a workbook have?

Chris Kenway, Content Writer
Answered: Jun 27, 2018

You may have a little more than 200 worksheets in a workbook. Take note that by default, Excel will show up to 3 worksheets but you can always add more tabs depending on your needs. Do take note...Read More

2 Answers

536 views

How do you know a range is active?

Kritikajoshi
Answered: Apr 25, 2024

It is highlighted on the screen.

1 Answer

525 views

What is the formula that will add D4 to the product of B1 plus B2?

Christian Jackson, Content Developer
Answered: Nov 11, 2018

In Excel, you can type in formulas into a cell so that you don’t have to type and type the same information into each cell. There may be a pattern to your data. You can create a formula...Read More

3 Answers

500 views

What happens when you select a cell with a date in it and drag the fill handle down and across several cells?

John Smith
Answered: Apr 25, 2024

The date is increased by 1 day into each cell

1 Answer

490 views

Can data be edited after saving the file in Microsoft excel?

Octara
Answered: Apr 25, 2024

Yes, even after saving the file, double click on the cell where data is to be changed to edit

1 Answer

488 views

Are all filters in the worksheet are cleared, when you clear a filter if worksheet contains more than one filters?

Octara
Answered: Apr 25, 2024

False

1 Answer

438 views

Which menu option can be used to split windows into two in Microsoft excel?

N. Kingsley, Writer
Answered: May 06, 2019

The correct answer to this question is View –> Split. This function can be used in the Microsoft spreadsheet program, Excel. This split screen feature allows one to view multiple copies of...Read More

2 Answers

436 views

What is a way to center a title across the top of the data (from column A to column E)?

Markda John
Answered: Jan 01, 2018

One of the best ways to make a title centered in the A1 to E1 row is actually pretty simple. The answer is to type the title into the A1 cell, and then merge all the cells between A1 and E1. This...Read More

2 Answers

430 views

How do you know a range is active?

Wyatt Williams
Answered: Apr 25, 2024

It is highlighted on the screen.

1 Answer

397 views

Is it possible to insert an image from a file into an Excel spreadsheet?

ReneeMoats
Answered: Mar 06, 2017

Yes

2 Answers

396 views

How should you print a selected area of a worksheet, if you'll want to print a different area next time? A. On the File menu, point to Print Area, and then click Set Print Area. B....

L. Hawkes, Teacher
Answered: Jul 03, 2018

If you do not wish to print an entire worksheet, but only a portion, you highlight your selection, then select on the printer options "selection" rather than "print all". After printing has...Read More

2 Answers

394 views

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

Shane.clay
Answered: Apr 25, 2024

Rows, rows, Row, row

1 Answer

373 views

Which menu option can be used to split windows into two?

L. Sevigny, Doctor
Answered: Jan 04, 2019

There are times when you are working on a computer and you need your screen or window split. If you need your screen split, then there are certain steps that you will need to do to make sure you...Read More

2 Answers

327 views

Microsoft Excel Questions and Answers (Q&A)

Related