01/23/23

Microsoft Excel

if a cell contains a value with a date format, such as DD/MM/YYYY, the cells contents will be automatically aligned to the left hand side of the cell A True B False
Follows • 1
Expert Answers •1

01/23/23

Which of the following menus in the page setup dialog box can be used to repeat the header row of a long table on every printed page A page B margin C Head/porter D sheet E margin and sheet
Follows • 1
Expert Answers •1

01/20/23

which of the following functions can be use to calculate the total sum of a filtered value

Follows • 1
Expert Answers •1

09/25/21

A color can be dramatically affected by the colors that surround it.
Follows • 1
Expert Answers •1

08/14/21

Assign value to First and Last row of each group.
This is My Table+------------------------+| id | session ID | bal |+------------------------+| 0 | 00000002 | 100 || 1 | 00000002 | 120 || 2 | 00000002 | 140 || 3 | 00000001 | 900 ... more
Follows • 1
Expert Answers •2

08/12/21

Urgent please solve this Excel problem
Below is an extract of my Excel data A 20160101 A 20160104 A 20160105 A 20160106 A 20160107 AA 20160108 AA 20160111 AA 20160112 AA 20160113 AA 20160114 AA 20160115 AA 20160118 AB ... more
Follows • 1
Expert Answers •2

07/27/21

How Do I Create a Vlookup?
Follows • 1
Expert Answers •2

07/23/21

Excel: I need to take given data and sort between f, d, or Both. Then I need to separate the data once determined by f or d pounds
So, imagine there is an excel sheet with a column full of f or d values, another with random minute values, and 5 different zone columns with a number in only one of these per row(These 5 columns... more
Follows • 1
Expert Answers •1

06/03/21

How do I link data in one worksheet to another?
Reduce time required to prepare Excel worksheets by inputting data into a primary worksheet and then linking other worksheets to it. This will not only reduce preparation time, but also reduce the... more
Follows • 1
Expert Answers •2

04/30/21

Excel Spreadsheets
Hi Brian, What formula pulls data from multiple columns from four different sheets into one sheet connected to a drop down list with multiple names?
Follows • 1
Expert Answers •2

03/29/21

How to add greater than in Excel Solver
I have a linear constraints as X>Y, and I need to add it into Excel Solver. But the option in add-in just have >=, <= or =. So what should I do?
Follows • 1
Expert Answers •1

03/27/21

Having issue with Excel 2019
In cell N5, enter an INDEX FUNCTION that will retrieve the name of the movie with the highest gross sales, Write the function as the array argument.
Follows • 2
Expert Answers •2

03/04/21

Why are the rows and columns of my pivot table showing blank when there is data?
Follows • 1
Expert Answers •2

08/29/20

What is the number?

The product of 3 and a number increased by 7 is -36
Follows • 0
Expert Answers •1

08/28/20

You deposited $1200 in a savings account that earns a simple interest rate of 1.8% per year. You want to keep the money in the account for 11 years. How much interest will you earn?

Follows • 1
Expert Answers •3

08/28/20

In a survey, 60% of students prefer bagels to donuts. If 120 students were surveyed, how many students prefer bagels?

Follows • 1
Expert Answers •3

09/17/19

Find the next two terms of sequence
U0 = 1U1 =3And Un is defined by Un+2 = 2 * Un+1 + 3 * UnFind the next two terms
Follows • 1
Expert Answers •2

06/14/19

Number field turned out as text in Excel, SSRS?
My SSRS reports one of the field is using this expression, where the field is a number field. I want to see blank field is the value is `0`. =IIf(Fields!PERIOD02_VALUE.Value <>... more
Follows • 1
Expert Answers •1

05/03/19

Click a button and the button would be unable to be clicked until reset?
Is there a way I could be able to click a Button and then once the button has been clicked it would be Unable to be clicked until the Form reset itself. Say... Enabling Auto-Save and can't be... more
Follows • 1
Expert Answers •1

05/03/19

What does DIM stand for in Visual Basic and BASIC?
What does DIM stand for in Visual Basic?
Follows • 1
Expert Answers •1

05/03/19

How can I create a formula or button in Excel to automatically copy from a set point to the first reading of ISBLANK() =FALSE and then move the set point one below?
Follows • 1
Expert Answers •1

04/24/19

What are the difference between a BASIC GOTO and GOSUB statement?
What are the difference between a GOTO and a GOSUB statements in BASIC programming language?
Follows • 1
Expert Answers •1

04/23/19

Change output of textbox based on button clicked Visual Basic?
Hi everyone I am new to visual basic and am making my first program from a book I just bought and would like to change the output of my textbox based on the button I click for example if button1 is... more
Follows • 1
Expert Answers •1

05/07/18

excel problem
i have some names that are repeated often i want to use a function that uses persons names and nth time repetition of it as arguments to give me the row which indicate the person name and nth... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.